home *** CD-ROM | disk | FTP | other *** search
/ Amiga Collections: Taifun / Taifun 020 (1987-05-15)(Ossowski, Stefan)(DE)(PD).zip / Taifun 020 (1987-05-15)(Ossowski, Stefan)(DE)(PD).adf / Interest Accrued.sbq < prev    next >
Text File  |  1987-01-18  |  290b  |  7 lines
  1. DP
  2. Interest Accrued on Deposits
  3. Firstname.Clients,Lastname.Clients,Account,Amount,&8Interest, FIX (Amount * (Interest / 100) * ( TODAY - Date) / 365,2) AS "  Accrued"
  4. GROUP Lastname.Clients SUM "  Accrued"
  5. Lastname.Clients = Lastname.OldDeposits AND Bank Name = Bank
  6. Lastname.Clients
  7.